/*
 Navicat MySQL Data Transfer

 Source Server         : 127.0.0.1
 Source Server Version : 80012
 Source Host           : 127.0.0.1
 Source Database       : trm

 Target Server Version : 80012
 File Encoding         : utf-8

 Date: 02/25/2019 18:38:12 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `db_education_and_trainings`
-- ----------------------------
DROP TABLE IF EXISTS `db_education_and_trainings`;
CREATE TABLE `db_education_and_trainings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `edu_start_stop_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '起止时间',
  `school_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '学校名称',
  `professional` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '专业',
  `academic_degree` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '所获学历、学位',
  `resume_id` int(11) DEFAULT NULL COMMENT '简历编号',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_education_and_trainings`
-- ----------------------------
BEGIN;
INSERT INTO `db_education_and_trainings` VALUES ('1', '20170901-20180627', '房地讲小学', '挖掘机', '小学士', '1', '2019-02-14 02:58:55', '2019-02-14 03:11:35', null);
COMMIT;

-- ----------------------------
--  Table structure for `db_family_situations`
-- ----------------------------
DROP TABLE IF EXISTS `db_family_situations`;
CREATE TABLE `db_family_situations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '姓名',
  `relationship` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '关系',
  `engage_in_work` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '从事工作',
  `link_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系电话',
  `resume_id` int(11) DEFAULT NULL COMMENT '简历编号',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_family_situations`
-- ----------------------------
BEGIN;
INSERT INTO `db_family_situations` VALUES ('1', '姓名1', '父亲', '务农', '13038888888', '1', '2019-02-14 03:04:39', '2019-02-14 03:11:35', null), ('2', '姓名1', '父亲', '务农', '13038888888', '1', '2019-02-14 03:04:39', '2019-02-14 03:11:35', null);
COMMIT;

-- ----------------------------
--  Table structure for `db_interview_appraisals`
-- ----------------------------
DROP TABLE IF EXISTS `db_interview_appraisals`;
CREATE TABLE `db_interview_appraisals` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `resume_id` int(11) NOT NULL COMMENT '简历编号',
  `content` text COLLATE utf8mb4_unicode_ci COMMENT '意见',
  `interview_number` int(11) DEFAULT NULL COMMENT '面试次数',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Table structure for `db_interview_scores`
-- ----------------------------
DROP TABLE IF EXISTS `db_interview_scores`;
CREATE TABLE `db_interview_scores` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `resume_id` int(11) NOT NULL COMMENT '简历表编号',
  `grooming` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '仪容仪表',
  `ability_to_respond_and_express` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '反应及表达能力',
  `relevant_working_experience` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '相关工作经验',
  `degree_of_confidence` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自信程度',
  `professional_knowledge` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '对专业知识的掌握程度',
  `degree_of_reaction` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '所具经验与本公司业务的反应程度',
  `general_knowledge_of_the_company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '对本公司一般情况下的了解程度',
  `stability` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '稳定性',
  `cooperative` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '合作性',
  `willingness_to_work` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '前来公司工作的意愿',
  `overall_rating` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '总评',
  `grades` int(11) DEFAULT '1' COMMENT '档级1:1档(默认)2:2档3:3档4:其他',
  `rank` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '职级',
  `salary_range` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '薪资幅度',
  `opinion_of_personnel_department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用人单位意见',
  `opinions_of_the_employing_department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用人部门意见',
  `opinions_of_the_manager` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '经理意见',
  `special_salary` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '特殊薪资',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_interview_scores`
-- ----------------------------
BEGIN;
INSERT INTO `db_interview_scores` VALUES ('1', '1', '仪容仪表', '反应及表达能力', '相关工作经验', '自信程度', '对专业知识的掌握程度', '所具经验与本公司业务的反应程度', '对本公司一般情况下的了解程度', '稳定性', '合作性', '前来公司工作的意愿', '总评', '1', '1', '薪资幅度', '用人单位意见', '用人部门意见', null, '特殊薪资', '2019-02-15 06:23:47', '2019-02-15 12:55:53', null);
COMMIT;

-- ----------------------------
--  Table structure for `db_invitation_codes`
-- ----------------------------
DROP TABLE IF EXISTS `db_invitation_codes`;
CREATE TABLE `db_invitation_codes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `str_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邀请码',
  `code_type` int(11) NOT NULL COMMENT '邀请码类型：1:HR2 :管理员',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_invitation_codes`
-- ----------------------------
BEGIN;
INSERT INTO `db_invitation_codes` VALUES ('5', 'hr', '1', null, null, null), ('6', 'yrdw', '2', null, null, null), ('7', 'jl', '3', null, null, null), ('8', 'boss', '4', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `db_login_permissions`
-- ----------------------------
DROP TABLE IF EXISTS `db_login_permissions`;
CREATE TABLE `db_login_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `wxuser_id` int(11) NOT NULL COMMENT '微信编号',
  `login_type_id` int(11) DEFAULT NULL COMMENT '登陆权限',
  `status` tinyint(4) DEFAULT '1' COMMENT '用户登陆状态',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_login_permissions`
-- ----------------------------
BEGIN;
INSERT INTO `db_login_permissions` VALUES ('1', '1', '1', '1', '2019-02-18 08:05:50', '2019-02-18 08:05:50', null), ('2', '1', '4', '1', '2019-02-18 09:00:01', '2019-02-18 09:00:01', null), ('3', '1', '3', '1', '2019-02-18 09:00:01', '2019-02-18 09:00:01', null);
COMMIT;

-- ----------------------------
--  Table structure for `db_migrations`
-- ----------------------------
DROP TABLE IF EXISTS `db_migrations`;
CREATE TABLE `db_migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_migrations`
-- ----------------------------
BEGIN;
INSERT INTO `db_migrations` VALUES ('1', '2019_01_21_075103_create_wxusers_table', '1'), ('2', '2019_01_21_081719_create_invitation_codes_table', '1'), ('3', '2019_01_21_090243_create_login_permissions_table', '1'), ('4', '2019_01_21_090301_create_resumes_table', '1'), ('5', '2019_01_21_095943_create_resumes_infos_table', '1'), ('6', '2019_01_22_065250_create_family_situations_table', '1'), ('9', '2019_01_22_065701_create_work_experiences_table', '2'), ('10', '2019_01_22_065807_create_education_and_trainings_table', '2'), ('14', '2019_01_26_102600_create_pictures_categorys_table', '3'), ('21', '2019_01_29_094625_create_rank_salarys_table', '4'), ('23', '2019_01_29_035509_create_interview_appraisals_table', '5'), ('25', '2019_01_28_071334_create_interview_scores_table', '6'), ('26', '2019_01_26_102520_create_pictures_table', '7'), ('27', '2019_02_15_120526_create_sms_temps_table', '8');
COMMIT;

-- ----------------------------
--  Table structure for `db_pictures`
-- ----------------------------
DROP TABLE IF EXISTS `db_pictures`;
CREATE TABLE `db_pictures` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `resume_id` int(11) NOT NULL COMMENT '简历表编号',
  `img_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片地址',
  `img_type` int(11) DEFAULT NULL COMMENT '图片类型',
  `img_alt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_pictures`
-- ----------------------------
BEGIN;
INSERT INTO `db_pictures` VALUES ('1', '1', 'http://trm.inforward.com.cn/storage/20190215123740.jpg', '2', null, null, '2019-02-15 11:54:49', '2019-02-15 12:37:40'), ('2', '2', 'http://trm.inforward.com.cn/storage/20190215123740.jpg', '2', null, null, '2019-02-15 11:54:49', '2019-02-15 11:54:49'), ('3', '66', '[Null]dsf', '1', null, null, null, null), ('4', '66', 'dsf[Null]', '2', null, null, null, null), ('5', '66', 'dsf[Null]', '3', null, null, null, null), ('6', '66', 'dsf[Null]', '4', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `db_pictures_categorys`
-- ----------------------------
DROP TABLE IF EXISTS `db_pictures_categorys`;
CREATE TABLE `db_pictures_categorys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `pic_type` tinyint(4) DEFAULT NULL COMMENT '图片类型',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_pictures_categorys`
-- ----------------------------
BEGIN;
INSERT INTO `db_pictures_categorys` VALUES ('1', '证件照', '1', null, null, null), ('2', '全身照1', '1', null, null, null), ('3', '全身照2', '1', null, null, null), ('4', '附件简历', '1', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `db_rank_salarys`
-- ----------------------------
DROP TABLE IF EXISTS `db_rank_salarys`;
CREATE TABLE `db_rank_salarys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名字',
  `paranet_id` int(11) DEFAULT NULL COMMENT '父类ID',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Table structure for `db_resumes`
-- ----------------------------
DROP TABLE IF EXISTS `db_resumes`;
CREATE TABLE `db_resumes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `jobs` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应聘岗位',
  `salary_requirements` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '薪资要求',
  `date_of_filling` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '填表日期',
  `wxuser_id` int(11) DEFAULT NULL COMMENT '微信用户id',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `status` int(11) NOT NULL COMMENT '状态：0: 待审核(默认)1: 待评估2: 待复评3：待审核 4: 聘用5: 候选6: 储备-1: 人才库',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_resumes`
-- ----------------------------
BEGIN;
INSERT INTO `db_resumes` VALUES ('1', '应聘岗位', '薪资要求', '填表日期', '1', '2019-02-14 02:43:39', '2019-02-25 07:47:31', null, '-1'), ('2', 'PHP开发工程师', '11k', '2019-01-31', '1', '2019-02-14 03:11:35', '2019-02-14 03:11:35', null, '1'), ('3', '人事主管', '9k', null, null, '2019-02-14 10:43:45', '2019-02-14 10:43:45', null, '-3'), ('4', 'Web前端工程师', '11k', null, null, '2019-02-15 03:16:19', '2019-02-15 03:16:19', null, '-1');
COMMIT;

-- ----------------------------
--  Table structure for `db_resumes_infos`
-- ----------------------------
DROP TABLE IF EXISTS `db_resumes_infos`;
CREATE TABLE `db_resumes_infos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `resume_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '简历编号',
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '姓名',
  `sex` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '性别',
  `political_landscape` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '政治面貌',
  `examination_situation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '婚育情况',
  `national` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '民族',
  `constellation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '星座',
  `chinese_zodiac` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '生肖',
  `weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '体重',
  `height` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '身高',
  `native_place` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '籍贯',
  `mobile_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系方式',
  `wechat_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信号',
  `identification_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '身份证号码',
  `arrival_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '到岗时间',
  `education_background` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '学历',
  `degree` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '学位',
  `professional` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '专业',
  `current_residential_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '现居住地点',
  `emergency_contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '紧急联系人姓名',
  `emergency_contact_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '紧急联系人电话',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_resumes_infos`
-- ----------------------------
BEGIN;
INSERT INTO `db_resumes_infos` VALUES ('1', '1', '姓名', '性别', '政治面貌', '婚育情况', '民族', '星座', '生肖', '体重', '身高', '籍贯', '联系方式', '微信号', '身份证号码', '到岗时间', '学历', '学位', '专业', '现居住地点', '紧急联系人姓名', '紧急联系人电话', '2019-02-14 02:43:39', '2019-02-14 03:04:39', null), ('2', '2', '白俊生', '男', '党员', '否', '汉', '金牛座', '狗', '123', '183', '广州', '18818888888', 'wx_122daf', '421900200303484765', '随时', '本科', '电子商务B级', '电子商务', '广东省广州市天河区石牌桥', '百晓生', '13030000019', '2019-02-14 03:11:35', '2019-02-14 03:11:35', null), ('3', '3', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2019-02-14 10:43:45', '2019-02-14 10:43:45', null), ('4', '4', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2019-02-15 03:16:19', '2019-02-15 03:16:19', null);
COMMIT;

-- ----------------------------
--  Table structure for `db_sms_temps`
-- ----------------------------
DROP TABLE IF EXISTS `db_sms_temps`;
CREATE TABLE `db_sms_temps` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mobile_phone` char(11) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '联系电话',
  `qr_code` char(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '二维码',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_sms_temps`
-- ----------------------------
BEGIN;
INSERT INTO `db_sms_temps` VALUES ('1', '13038803510', '986849', null, '2019-02-15 12:35:20', '2019-02-20 10:24:28');
COMMIT;

-- ----------------------------
--  Table structure for `db_work_experiences`
-- ----------------------------
DROP TABLE IF EXISTS `db_work_experiences`;
CREATE TABLE `db_work_experiences` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `work_start_stop_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '起止时间',
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公司名称',
  `department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '部门',
  `position` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '职位',
  `compensation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '薪酬',
  `leaving_reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '离职原因',
  `references_and_telephone_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resume_id` int(11) DEFAULT NULL COMMENT '简历编号',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_work_experiences`
-- ----------------------------
BEGIN;
INSERT INTO `db_work_experiences` VALUES ('1', '20181001-20181231', '完胜科技公司', '技术部', 'PHP工程师', '8k', '公司倒闭', '白俊生', '1', '2019-02-14 03:03:39', '2019-02-14 03:11:35', null);
COMMIT;

-- ----------------------------
--  Table structure for `db_wxusers`
-- ----------------------------
DROP TABLE IF EXISTS `db_wxusers`;
CREATE TABLE `db_wxusers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `open_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '小程序open_id',
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信open_id',
  `nick_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
  `head_image_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no.jpg' COMMENT '头像',
  `sex` int(11) DEFAULT NULL COMMENT '性别',
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '国家',
  `province` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '省',
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '城市',
  `subscribe` int(11) DEFAULT NULL COMMENT '是否关注公众号',
  `subscribe_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '关注时间',
  `setp` int(11) DEFAULT NULL COMMENT '级别',
  `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户token',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `db_wxusers`
-- ----------------------------
BEGIN;
INSERT INTO `db_wxusers` VALUES ('1', '033oJ5jL0ECxu92egXhL0lVmjL0oJ5jB', '1', 'dsfa', 'fdas', '1', 'dfa', 'dsf', 'dfsa', '1', '2018-12-30', '1', '77e8cf33b858b380a5e75c2d3a13fda27bb063df', '2019-02-18 08:02:48', '2019-02-18 09:01:58', null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
